OpenEdge Data Management:<br />SQL Reference Conditional expression

Release 10.1A: OpenEdge Data Management:
SQL Reference

Conditional expression

Case expression

A type of conditional expression.

Syntax
case_expr ::=
searched_case_expr | simple_case_expr 
Searched case expression
Syntax
searched_case_expr ::=
CASE
  WHEN search_condition THEN { result_expr | NULL } [ , ... ]
[ ELSE expr | NULL ]
END 
Simple case expression
Syntax
simple_case_expr ::=
CASE primary_expr
  WHEN expr THEN { result_expr | NULL } [ , ... ]
[ ELSE expr | NULL ]
END 